/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : SQL Server
 Source Server Version : 10501600
 Source Host           : 127.0.0.1:1433
 Source Catalog        : testdb
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 10501600
 File Encoding         : 65001

 Date: 01/05/2019 09:48:18
*/


-- ----------------------------
-- Table structure for rel_data_auth
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rel_data_auth]') AND type IN ('U'))
	DROP TABLE [dbo].[rel_data_auth]
GO

CREATE TABLE [dbo].[rel_data_auth] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [UserNo] varchar(5) COLLATE Chinese_PRC_CI_AS  NULL,
  [Store] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [ScopeId] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [ScopeType] int DEFAULT ((0)) NULL,
  [CreateTime] datetime  NULL,
  [CreateManNo] varchar(5) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditTime] datetime  NULL,
  [EditManNo] varchar(5) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[rel_data_auth] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'人员编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'UserNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'中心店面Ids',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'Store'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据范围部门Ids',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'ScopeId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型 0：允许看全部 1：只允许查看个人数据 2：允许查看部门数据 ',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'ScopeType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'CreateManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人姓名',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'CreateManName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑时间',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'EditTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'EditManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人姓名',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth',
'COLUMN', N'EditManName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据范围授权表',
'SCHEMA', N'dbo',
'TABLE', N'rel_data_auth'
GO


-- ----------------------------
-- Table structure for rel_role_limit
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rel_role_limit]') AND type IN ('U'))
	DROP TABLE [dbo].[rel_role_limit]
GO

CREATE TABLE [dbo].[rel_role_limit] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [RoleId] int  NULL,
  [LimParentId] int  NULL,
  [LimitId] int  NULL,
  [CreateTime] datetime  NULL,
  [CreateManNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[rel_role_limit] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_limit',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_limit',
'COLUMN', N'RoleId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'资源父节点Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_limit',
'COLUMN', N'LimParentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'资源Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_limit',
'COLUMN', N'LimitId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_limit',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_limit',
'COLUMN', N'CreateManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人姓名',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_limit',
'COLUMN', N'CreateManName'
GO


-- ----------------------------
-- Table structure for rel_role_scope
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rel_role_scope]') AND type IN ('U'))
	DROP TABLE [dbo].[rel_role_scope]
GO

CREATE TABLE [dbo].[rel_role_scope] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [RoleId] int  NULL,
  [Store] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [ScopeId] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [ScopeType] int  NULL,
  [Description] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateTime] datetime  NULL,
  [CreateManNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DelStatus] int DEFAULT ((1)) NULL,
  [EditManNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditTime] datetime  NULL
)
GO

ALTER TABLE [dbo].[rel_role_scope] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'RoleId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'中心店面',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'Store'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据范围Id(部门id) 0代表全部范围',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'ScopeId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型 1：只允许查看个人数据 2：允许查看所有人数据',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'ScopeType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'Description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'CreateManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人姓名',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'CreateManName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'1为可用状态 2为删除状态',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'DelStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'EditManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人姓名',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'EditManName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑时间',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope',
'COLUMN', N'EditTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色-数据范围',
'SCHEMA', N'dbo',
'TABLE', N'rel_role_scope'
GO


-- ----------------------------
-- Table structure for rel_user_auth
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rel_user_auth]') AND type IN ('U'))
	DROP TABLE [dbo].[rel_user_auth]
GO

CREATE TABLE [dbo].[rel_user_auth] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [UserNo] varchar(5) COLLATE Chinese_PRC_CI_AS  NULL,
  [RoleId] int  NULL,
  [RoleName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [LimitJson] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [Store] int  NULL,
  [Bm] int  NULL,
  [Gw] int  NULL,
  [CreateTime] datetime  NULL,
  [CreateManNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DelStatus] int DEFAULT ((1)) NULL,
  [EditTime] datetime  NULL,
  [EditManNo] varchar(5) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[rel_user_auth] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'人员编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'UserNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色Id',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'RoleId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'RoleName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色资源json',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'LimitJson'
GO

EXEC sp_addextendedproperty
'MS_Description', N'中心店面识别  0：总部 1：店面',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'Store'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'Bm'
GO

EXEC sp_addextendedproperty
'MS_Description', N'岗位',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'Gw'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'CreateManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人姓名',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'CreateManName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标志 1为可用状态 2为删除状态',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'DelStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑时间',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'EditTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'EditManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人姓名',
'SCHEMA', N'dbo',
'TABLE', N'rel_user_auth',
'COLUMN', N'EditManName'
GO


-- ----------------------------
-- Table structure for sys_limit
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_limit]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_limit]
GO

CREATE TABLE [dbo].[sys_limit] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [LimName] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [LimUrl] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [LimParentId] int  NULL,
  [LimLevel] int  NULL,
  [LimType] int  NULL,
  [CreateTime] datetime  NULL,
  [CreateManNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_limit] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限资源Id',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'资源名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'LimName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'资源路径',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'LimUrl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父节点Id 0: 代表父级为空',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'LimParentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'级别',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'LimLevel'
GO

EXEC sp_addextendedproperty
'MS_Description', N'资源类型  1：菜单 2：增删改查操作 3：敏感信息',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'LimType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'CreateManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人姓名',
'SCHEMA', N'dbo',
'TABLE', N'sys_limit',
'COLUMN', N'CreateManName'
GO


-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_role]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_role]
GO

CREATE TABLE [dbo].[tb_role] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [RoleName] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [RoleStatus] int  NULL,
  [RoleStore] int  NULL,
  [RoleBm] int  NULL,
  [RoleGw] int  NULL,
  [CreateTime] datetime  NULL,
  [CreateManNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditManNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditManName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [EditTime] datetime  NULL
)
GO

ALTER TABLE [dbo].[tb_role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色Id',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'RoleName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色状态 -1：不可用 1：可用',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'RoleStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'中心店面识别 0：总部 1：店面',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'RoleStore'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'RoleBm'
GO

EXEC sp_addextendedproperty
'MS_Description', N'岗位',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'RoleGw'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'CreateManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人姓名',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'CreateManName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人员工编号',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'EditManNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑人姓名',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'EditManName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编辑时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_role',
'COLUMN', N'EditTime'
GO


-- ----------------------------
-- Table structure for thislog
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[thislog]') AND type IN ('U'))
	DROP TABLE [dbo].[thislog]
GO

CREATE TABLE [dbo].[thislog] (
  [Operation] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [Method] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Params] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Ip] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateDate] datetime  NULL,
  [MenuIds] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ID] int  IDENTITY(1,1) NOT NULL
)
GO

ALTER TABLE [dbo].[thislog] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Primary Key structure for table rel_data_auth
-- ----------------------------
ALTER TABLE [dbo].[rel_data_auth] ADD CONSTRAINT [PK_REL_DATA_AUTH] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table rel_role_limit
-- ----------------------------
ALTER TABLE [dbo].[rel_role_limit] ADD CONSTRAINT [PK_REL_ROLE_LIMIT] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table rel_role_scope
-- ----------------------------
ALTER TABLE [dbo].[rel_role_scope] ADD CONSTRAINT [PK_REL_ROLE-SCOPE] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table rel_user_auth
-- ----------------------------
ALTER TABLE [dbo].[rel_user_auth] ADD CONSTRAINT [PK_REL_USER_AUTH] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_limit
-- ----------------------------
ALTER TABLE [dbo].[sys_limit] ADD CONSTRAINT [PK_SYS_LIMIT] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_role
-- ----------------------------
ALTER TABLE [dbo].[tb_role] ADD CONSTRAINT [PK_TB_ROLE] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table thislog
-- ----------------------------
ALTER TABLE [dbo].[thislog] ADD CONSTRAINT [PK__thislog__3214EC270425A276] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

